package guoanmaker.operator.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.w3c.dom.ls.LSInput;

import guoanmaker.operator.business.model.OperatorFinancingServiceDownNew;

public interface OperatorFinancingServiceDownNewRepository extends JpaRepository<OperatorFinancingServiceDownNew, String>, JpaSpecificationExecutor<OperatorFinancingServiceDownNew> {
	@Modifying
	@Query(value = "delete from t_operator_financing_service_down_new where financial_service_id=:financialServiceId", nativeQuery = true)
	public void deleteFinancingServiceDownNewByFinancialServiceId(@Param("financialServiceId") String financialServiceId);
	@Query("select f from OperatorFinancingServiceDownNew f where f.financialServiceId=:financialServiceId")
	public List<OperatorFinancingServiceDownNew> findFinancingServiceDownNewByFinancialServiceId(@Param("financialServiceId") String financialServiceId);
	
	public List<OperatorFinancingServiceDownNew> findByFinancialServiceId(@Param("financialServiceId") String financialServiceId);

}
